<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_goods`;");
E_C("CREATE TABLE `ecs_goods` (
  `goods_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_id` smallint(5) unsigned NOT NULL default '0',
  `goods_sn` varchar(60) NOT NULL default '',
  `goods_name` varchar(120) NOT NULL default '',
  `goods_name_style` varchar(60) NOT NULL default '+',
  `click_count` int(10) unsigned NOT NULL default '0',
  `brand_id` smallint(5) unsigned NOT NULL default '0',
  `provider_name` varchar(100) NOT NULL default '',
  `goods_number` smallint(5) unsigned NOT NULL default '0',
  `goods_weight` decimal(10,3) unsigned NOT NULL default '0.000',
  `market_price` decimal(10,2) unsigned NOT NULL default '0.00',
  `shop_price` decimal(10,2) unsigned NOT NULL default '0.00',
  `promote_price` decimal(10,2) unsigned NOT NULL default '0.00',
  `promote_start_date` int(11) unsigned NOT NULL default '0',
  `promote_end_date` int(11) unsigned NOT NULL default '0',
  `warn_number` tinyint(3) unsigned NOT NULL default '1',
  `keywords` varchar(255) NOT NULL default '',
  `goods_brief` varchar(255) NOT NULL default '',
  `goods_desc` text NOT NULL,
  `goods_thumb` varchar(255) NOT NULL default '',
  `goods_img` varchar(255) NOT NULL default '',
  `original_img` varchar(255) NOT NULL default '',
  `is_real` tinyint(3) unsigned NOT NULL default '1',
  `extension_code` varchar(30) NOT NULL default '',
  `is_on_sale` tinyint(1) unsigned NOT NULL default '1',
  `is_alone_sale` tinyint(1) unsigned NOT NULL default '1',
  `is_shipping` tinyint(1) unsigned NOT NULL default '0',
  `integral` int(10) unsigned NOT NULL default '0',
  `add_time` int(10) unsigned NOT NULL default '0',
  `sort_order` smallint(4) unsigned NOT NULL default '100',
  `is_delete` tinyint(1) unsigned NOT NULL default '0',
  `is_best` tinyint(1) unsigned NOT NULL default '0',
  `is_new` tinyint(1) unsigned NOT NULL default '0',
  `is_hot` tinyint(1) unsigned NOT NULL default '0',
  `is_promote` tinyint(1) unsigned NOT NULL default '0',
  `bonus_type_id` tinyint(3) unsigned NOT NULL default '0',
  `last_update` int(10) unsigned NOT NULL default '0',
  `goods_type` smallint(5) unsigned NOT NULL default '0',
  `seller_note` varchar(255) NOT NULL default '',
  `give_integral` int(11) NOT NULL default '-1',
  `rank_integral` int(11) NOT NULL default '-1',
  `suppliers_id` smallint(5) unsigned default NULL,
  `is_check` tinyint(1) unsigned default NULL,
  PRIMARY KEY  (`goods_id`),
  KEY `goods_sn` (`goods_sn`),
  KEY `cat_id` (`cat_id`),
  KEY `last_update` (`last_update`),
  KEY `brand_id` (`brand_id`),
  KEY `goods_weight` (`goods_weight`),
  KEY `promote_end_date` (`promote_end_date`),
  KEY `promote_start_date` (`promote_start_date`),
  KEY `goods_number` (`goods_number`),
  KEY `sort_order` (`sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_goods` values('1','209','ECS000000','惠普G4-1332TX 14英寸笔记本电脑 （i5-2450M 2G 500G 7450M 1G独显 D刻 无线 摄像头）一流品质，价格公道，放心使用！','+','467','1','','100','0.000','4678.80','3899.00','2999.00','1331568000','1394640000','1','','','','images/201203/thumb_img/1_thumb_G_1331565157288.jpg','images/201203/goods_img/1_G_1331565157764.jpg','images/201203/source_img/1_G_1331565157719.jpg','1','','1','1','0','38','1331565153','1','0','1','0','1','1','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('2','209','ECS000002','ThinkPad E42014英寸笔记本电脑（i5-2450M 2G 320G 蓝牙 摄像头）','+','6','2','','100','0.000','5038.80','4199.00','0.00','0','0','1','','','','images/201203/thumb_img/2_thumb_G_1331565268838.jpg','images/201203/goods_img/2_G_1331565268090.jpg','images/201203/source_img/2_G_1331565268497.jpg','1','','1','1','0','41','1331565268','100','0','1','0','1','0','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('3','209','ECS000003','宏碁AS4739-382G32Mnkk 14英寸笔记本电脑（i3-380M 2G 320G D刻 LED背光丽镜宽屏)黑色','+','26','3','','100','0.000','3358.79','2799.00','0.00','0','0','1','','','','images/201203/thumb_img/3_thumb_G_1331962017730.jpg','images/201203/goods_img/3_G_1331962017863.jpg','images/201203/source_img/3_G_1331962017737.jpg','1','','1','1','0','27','1331565433','100','0','1','0','1','0','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('4','209','ECS000004','三星Galaxy Tab P6800 7.7英寸 3G手机版 蓝牙3.0 魔丽屏 金属银','+','88','4','','100','0.000','5638.80','4699.00','0.00','0','0','1','','','','images/201203/thumb_img/4_thumb_G_1331565521378.jpg','images/201203/goods_img/4_G_1331565521363.jpg','images/201203/source_img/4_G_1331565521927.jpg','1','','1','1','0','46','1331565521','100','0','1','0','1','0','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('5','214','ECS000005','戴尔V260R-376台式电脑（双核i3-2120 2G内存 500G硬盘 1G独立显卡DVD 键鼠 三年上门服务)','+','9','5','','100','0.000','5758.80','4799.00','0.00','0','0','1','','','','images/201203/thumb_img/5_thumb_G_1331565609696.jpg','images/201203/goods_img/5_G_1331565609500.jpg','images/201203/source_img/5_G_1331565609261.jpg','1','','1','1','0','47','1331565609','100','0','1','0','1','0','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('6','214','ECS000006','惠普Pro3300 SFF QS798AV台式电脑（G630 2G 500G DVD 键鼠 三年上门服务）','+','21','6','','100','0.000','3598.79','2999.00','2500.00','1331568000','1394640000','1','','','','images/201203/thumb_img/6_thumb_G_1331565721367.jpg','images/201203/goods_img/6_G_1331565721486.jpg','images/201203/source_img/6_G_1331565721069.jpg','1','','1','1','0','29','1331565721','100','0','1','0','1','1','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('7','209','ECS000007','富士通LH531 14.1英寸笔记本电脑（i3-2350M 2G 320G 第二代核芯显卡 D刻 蓝牙HDMI win7）型动黑','+','18','7','','100','0.000','3598.79','2999.00','0.00','0','0','1','','','','images/201203/thumb_img/7_thumb_G_1331565819070.jpg','images/201203/goods_img/7_G_1331565819723.jpg','images/201203/source_img/7_G_1331565819709.jpg','1','','1','1','0','29','1331565819','100','0','1','0','1','0','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('8','209','ECS000008','清华同方精锐X2 台式电脑（双核E3500 2G 500G DVD 键鼠）带20英寸显示器','+','22','8','','100','0.000','2878.79','2399.00','0.00','0','0','1','','','','images/201203/thumb_img/8_thumb_G_1331964666078.jpg','images/201203/goods_img/8_G_1331964666949.jpg','images/201203/source_img/8_G_1331964666205.jpg','1','','1','1','0','23','1331565932','100','0','1','1','1','0','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('9','225','ECS000009','联想DP660平推式票据打印机','+','11','9','','100','0.000','1438.80','1199.00','0.00','0','0','1','','','','images/201203/thumb_img/9_thumb_G_1331566046239.jpg','images/201203/goods_img/9_G_1331566046373.jpg','images/201203/source_img/9_G_1331566046339.jpg','1','','1','1','0','11','1331566045','100','0','1','0','1','0','0','1333869251','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('10','84','ECS000010','直降100元！TCL118升冰箱！','+','0','17','','100','0.000','1198.80','999.00','800.00','1331913600','1394985600','1','','','','images/201203/thumb_img/10_thumb_G_1331960399482.jpg','images/201203/goods_img/10_G_1331960399053.jpg','images/201203/source_img/10_G_1331960399491.jpg','1','','1','1','0','9','1331960399','1','0','1','0','0','1','0','1332345555','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('11','84','ECS000011','飞利浦42英寸全高清液晶电视','+','0','18','','100','0.000','4185.59','3488.00','0.00','0','0','1','','','','images/201203/thumb_img/11_thumb_G_1331960446139.jpg','images/201203/goods_img/11_G_1331960446567.jpg','images/201203/source_img/11_G_1331960446922.jpg','1','','1','1','0','34','1331960446','2','0','1','1','0','0','0','1332345560','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('12','84','ECS000012','志高1匹挂机，买套装优惠700','+','0','17','','100','0.000','2278.79','1899.00','0.00','0','0','1','','','','images/201203/thumb_img/12_thumb_G_1331960493964.jpg','images/201203/goods_img/12_G_1331960493529.jpg','images/201203/source_img/12_G_1331960493529.jpg','1','','1','1','0','18','1331960493','4','0','1','0','0','0','0','1332345588','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('13','84','ECS000013','帅康不锈钢联动套装！厨卫节抢','+','4','18','','100','0.000','3945.60','3288.00','2999.00','1331913600','1394985600','1','','','','images/201203/thumb_img/13_thumb_G_1331960541337.jpg','images/201203/goods_img/13_G_1331960541266.jpg','images/201203/source_img/13_G_1331960541286.jpg','1','','1','1','0','32','1331960541','3','0','1','0','0','1','0','1332345631','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('14','84','ECS000014','新品上市，真正智能专家！ 下单','+','0','14','','100','0.000','2518.79','2099.00','0.00','0','0','1','','','','images/201203/thumb_img/14_thumb_G_1331960576431.jpg','images/201203/goods_img/14_G_1331960576133.jpg','images/201203/source_img/14_G_1331960576800.jpg','1','','1','1','0','20','1331960576','5','0','1','0','0','0','0','1332345566','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('15','84','ECS000015','直降150元！西门子5.6公斤超薄','+','1','10','','100','0.000','4363.20','3636.00','0.00','0','0','1','','','','images/201203/thumb_img/15_thumb_G_1331960610977.jpg','images/201203/goods_img/15_G_1331960610381.jpg','images/201203/source_img/15_G_1331960610145.jpg','1','','1','1','0','36','1331960610','6','0','1','1','1','0','0','1332345569','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('16','95','ECS000016','2197劲爆促销！索尼32英寸高清','+','6','10','','100','0.000','3034.79','2529.00','0.00','0','0','1','','','','images/201203/thumb_img/16_thumb_G_1331960657423.jpg','images/201203/goods_img/16_G_1331960656274.jpg','images/201203/source_img/16_G_1331960656171.jpg','1','','1','1','0','25','1331960656','7','0','1','1','1','0','0','1332345571','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('17','116','ECS000017','直降200元！TCL正1.5匹空调','+','8','11','','100','0.000','2518.79','2099.00','1800.00','1331913600','1394985600','1','','','','images/201203/thumb_img/17_thumb_G_1331960702174.jpg','images/201203/goods_img/17_G_1331960702111.jpg','images/201203/source_img/17_G_1331960702022.jpg','1','','1','1','0','20','1331960702','8','0','1','0','0','1','0','1332345574','0','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('18','262','ECS000018','兰蔻水份缘舒缓精华液 30ml','+','10','21','','100','0.000','682.80','569.00','0.00','0','0','1','','','','images/201203/thumb_img/18_thumb_G_1331965422274.jpg','images/201203/goods_img/18_G_1331965422446.jpg','images/201203/source_img/18_G_1331965422243.jpg','1','','1','1','0','5','1331965421','100','0','1','0','1','0','0','1331968345','0','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('19','262','ECS000019','资生堂ZA沁漾保湿乳液','+','0','26','','100','0.000','126.00','105.00','0.00','0','0','1','','','','images/201203/thumb_img/19_thumb_G_1331965459123.jpg','images/201203/goods_img/19_G_1331965459789.jpg','images/201203/source_img/19_G_1331965459525.jpg','1','','1','1','0','1','1331965459','100','0','1','0','0','0','0','1331966946','0','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('20','262','ECS000020','只要169元！！3月特献~~','+','1','25','','100','0.000','202.79','169.00','0.00','0','0','1','','','','images/201203/thumb_img/20_thumb_G_1331965497536.jpg','images/201203/goods_img/20_G_1331965497248.jpg','images/201203/source_img/20_G_1331965497468.jpg','1','','1','1','0','1','1331965497','100','0','1','0','0','0','0','1331966946','0','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('21','262','ECS000021','长生鸟护肤珍珠粉15g','+','0','25','','100','0.000','105.60','88.00','0.00','0','0','1','','','','images/201203/thumb_img/21_thumb_G_1331967131264.jpg','images/201203/goods_img/21_G_1331967131688.jpg','images/201203/source_img/21_G_1331967131426.jpg','1','','1','1','0','0','1331965531','100','0','1','0','0','0','0','1331967131','0','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('22','268','ECS000022','金狐狸foxer时尚印花手提包','+','0','20','','100','0.000','238.79','199.00','0.00','0','0','1','','','','images/201203/thumb_img/22_thumb_G_1331965608062.jpg','images/201203/goods_img/22_G_1331965608325.jpg','images/201203/source_img/22_G_1331965608211.jpg','1','','1','1','0','1','1331965608','100','0','1','0','0','0','0','1331980596','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('23','268','ECS000023','ELLE(她)PVC配牛皮女士钱包','+','0','27','','100','0.000','598.80','499.00','0.00','0','0','1','','','','images/201203/thumb_img/23_thumb_G_1331965658651.jpg','images/201203/goods_img/23_G_1331965658482.jpg','images/201203/source_img/23_G_1331965658620.jpg','1','','1','1','0','4','1331965658','100','0','1','0','1','0','0','1331980584','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('24','268','ECS000024','周生生 黄金(足金)天使系列','+','23','22','','100','0.000','2160.00','1800.00','0.00','0','0','1','','','','images/201203/thumb_img/24_thumb_G_1331965687700.jpg','images/201203/goods_img/24_G_1331965687569.jpg','images/201203/source_img/24_G_1331965686628.jpg','1','','1','1','0','18','1331965686','100','0','1','0','0','0','0','1331966946','0','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('25','268','ECS000025','SilverAge心心相印银手链','+','0','22','','100','0.000','240.00','200.00','0.00','0','0','1','','','','images/201203/thumb_img/25_thumb_G_1331965709155.jpg','images/201203/goods_img/25_G_1331965709775.jpg','images/201203/source_img/25_G_1331965709146.jpg','1','','1','1','0','2','1331965709','100','0','1','0','0','0','0','1331980479','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('26','247','ECS000026','占姆士JamesKingdom男士法兰绒纯棉长袖衬衫黑底蓝色格纹时尚休闲版J51XC0008 蓝色 43','+','0','12','','100','0.000','298.80','249.00','0.00','0','0','1','','','','images/201203/thumb_img/26_thumb_G_1331966058972.jpg','images/201203/goods_img/26_G_1331966058990.jpg','images/201203/source_img/26_G_1331966058141.jpg','1','','1','1','0','2','1331966057','100','0','1','0','1','0','0','1331980464','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('27','247','ECS000027','长袖条纹衬衫高品质商务正装衬衫 AC-30699 深蓝085 175/100A袖长33','+','0','27','','100','0.000','322.80','269.00','0.00','0','0','1','','','','images/201203/thumb_img/27_thumb_G_1331966164648.jpg','images/201203/goods_img/27_G_1331966164426.jpg','images/201203/source_img/27_G_1331966164035.jpg','1','','1','1','0','2','1331966164','100','0','1','0','1','0','0','1331980454','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('28','247','ECS000028','Giordano佐丹奴 衬衫 男浅纹质感优棉衬衫 01040553 深灰 M','+','0','27','','100','0.000','201.60','168.00','0.00','0','0','1','','','','images/201203/thumb_img/28_thumb_G_1331966252311.jpg','images/201203/goods_img/28_G_1331966252394.jpg','images/201203/source_img/28_G_1331966252566.jpg','1','','1','1','0','1','1331966251','100','0','1','1','0','0','0','1331980440','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('29','247','ECS000029','Giordano佐丹奴 衬衫 男浅纹质感优棉衬衫 01040553 灰色 XL','+','0','27','','100','0.000','201.60','168.00','0.00','0','0','1','','','','images/201203/thumb_img/29_thumb_G_1331966357126.jpg','images/201203/goods_img/29_G_1331966357599.jpg','images/201203/source_img/29_G_1331966357284.jpg','1','','1','1','0','1','1331966357','100','0','1','0','0','0','0','1331980423','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('30','247','ECS000030','奥古仕盾auxtun 春季新款Knight骑士风范和绅士风度 男士日常休闲皮鞋 9701 棕色 43','+','0','23','','100','0.000','225.60','188.00','0.00','0','0','1','','','','images/201203/thumb_img/30_thumb_G_1331966483626.jpg','images/201203/goods_img/30_G_1331966483155.jpg','images/201203/source_img/30_G_1331966483636.jpg','1','','1','1','0','1','1331966483','100','0','1','1','0','0','0','1331980410','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('31','257','ECS000031','PUBGO步步高头层牛皮商务鞋M11422315 黑色 43','+','0','19','','100','0.000','262.80','219.00','0.00','0','0','1','','','','images/201203/thumb_img/31_thumb_G_1331966578274.jpg','images/201203/goods_img/31_G_1331966578070.jpg','images/201203/source_img/31_G_1331966578064.jpg','1','','1','1','0','2','1331966578','100','0','1','0','0','0','0','1331980395','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('32','257','ECS000032','圣高2012新款男式正装内增高皮鞋男鞋9988D 黑色 42','+','0','13','','100','0.000','576.00','480.00','0.00','0','0','1','','','','images/201203/thumb_img/32_thumb_G_1331966698074.jpg','images/201203/goods_img/32_G_1331966698845.jpg','images/201203/source_img/32_G_1331966698935.jpg','1','','1','1','0','4','1331966698','100','0','1','0','0','0','0','1331980380','2','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('33','257','ECS000033','策恩CEEN 帕米尔-兰斯 小牛皮贵族式高端休闲男皮鞋 X0023 褐色 44','+','33','13','','100','0.000','238.79','199.00','0.00','0','0','1','','','','images/201203/thumb_img/33_thumb_G_1331966807548.jpg','images/201203/goods_img/33_G_1331966807061.jpg','images/201203/source_img/33_G_1331966807041.jpg','1','','1','1','0','1','1331966806','100','0','1','0','1','0','0','1332988075','2','','-1','-1','0','0');");

require("../../inc/footer.php");
?>